with airbyte cloud can i see the tables with the prefix "raw" of the ingestion?

Yes, with Airbyte, you can view the raw tables of the data ingestion. These tables are named with the prefix "airbyte_raw". They contain the raw JSON data that was fetched from the source and have 3 columns: _airbyte_ab_id, airbyte_emitted_at, _airbyte_data. For example, if you want to view the raw table in a Postgres destination, you can execute the following command:

sql SELECT * FROM _airbyte_raw_table_name;

Replace "_airbyte_raw_table_name" with the actual name of your raw table. Please note that the raw tables are created during the sync operation. After a successful sync, you should be able to see the data in your destination. If you go to your dataset, you'll see that several sets of tables were created, including the raw tables. For more details, you can refer to these tutorials: - [Export Google Analytics data to BigQuery](https://airbyte.com/tutorials/export-google-analytics-to-bigquery) - [Explore Airbyte’s incremental data synchronization](https://airbyte.com/tutorials/incremental-data-synchronization) - [Explore Airbyte's full refresh data synchronization](https://airbyte.com/tutorials/full-data-synchronization) - [Explore Airbyte's Change Data Capture (CDC) synchronization](https://airbyte.com/tutorials/incremental-change-data-capture-cdc-replication)