Airbyte is an open-source data integration engine that helps you consolidate your data in your data warehouses, lakes and databases.

Airbyte

Hi there.  I use Airbyte to sync tables from Postgres to Snowflake.  Is there an easy way to make Airbyte tables (e.g. _AIRBYTE_RAW_*) as transient tables, instead of permanent tables?

By default, Airbyte creates permanent tables in Snowflake. If you prefer transient tables, you can create a dedicated transient database for Airbyte. For more information, refer to [Working with Temporary and Transient Tables](<https://docs.snowflake.com/en/user-guide/tables-temp-transient.html>) in Snowflake's documentation.  However, there isn't a direct way to configure Airbyte to create transient tables automatically. You can consider creating a separate schema for Airbyte tables and manage the table types manually within Snowflake.  Source: [Airbyte Snowflake Destination Documentation](<https://docs.airbyte.com/integrations/destinations/snowflake>)