Why Is There an Empty Schema Named FIVETRAN_%%%%%_STAGING in the Destination?

Question

Why is Fivetran creating an empty schema named FIVETRAN_%%%%%_STAGING in the destination?

Environment

Destinations

Answer

Fivetran creates a temporary schema to do intermediate processing, such as creating staging tables, before the data is uploaded to your destination. At the end of processing, this schema will always be empty. For more information, see our documentation.

The schema name is always in the FIVETRAN_GROUPID_STAGING format. The group ID is a unique identifier Fivetran uses to identify each group.