SnowPro Advanced Data Engineer

A full Snowflake account in the provider’s region can consume the Marketplace data; a reader account cannot serve this purpose because it can consume data only from the account that created it. Replicating the acquired data to the company account makes it available alongside the company’s existing data, where the pipeline can transform and blend it. Snowflake’s cross-region sharing guidance describes replication as the mechanism for making data available across regions and cloud platforms.

OBJECT_CONSTRUCT creates a Snowflake OBJECT directly from relational column values; with a wildcard, it uses column names as object keys. This produces one semi-structured object per row without first serializing or parsing JSON, or converting each column individually.

Snowflake supports loading selected staged-file columns through a COPY INTO ... FROM (SELECT ...) transformation. A transformation cannot use WHERE or LIMIT, and VALIDATION_MODE is unsupported for transformed COPY loads and performs validation rather than loading data.

SKIP_HEADER specifies the number of lines at the beginning of a CSV file that Snowflake skips during loading. Setting it to 1 excludes one header record from the loaded data.

Snowflake SQL API requests can authenticate programmatically with an OAuth bearer token or with key-pair authentication, which uses a JWT generated from an assigned public/private key pair. MFA and browser-based SSO methods are not the SQL API request authentication methods.