dlt.destinations.impl.snowflake.utils

gen_copy_sql

def gen_copy_sql(
        file_url: str,
        qualified_table_name: str,
        loader_file_format: TLoaderFileFormat,
        is_case_sensitive: bool,
        stage_name: Optional[str] = None,
        stage_bucket_url: Optional[str] = None,
        local_stage_file_path: Optional[str] = None,
        staging_credentials: Optional[CredentialsConfiguration] = None,
        csv_format: Optional[CsvFormatConfiguration] = None,
        use_vectorized_scanner: Optional[bool] = False) -> str

View source on GitHub

Generates a Snowflake COPY command to load data from a file.

Arguments:

• use_vectorized_scanner - Whether to use the vectorized scanner in COPY INTO
• file_url - URL of the file to load
• qualified_table_name - Fully qualified name of the target table
• loader_file_format - Format of the source file (jsonl, parquet, csv)
• is_case_sensitive - Whether column matching should be case-sensitive
• stage_name - Optional name of a predefined Snowflake stage
• stage_bucket_url - Optional URL of the bucket containing the file
• local_stage_file_path - Path to use for local files
• staging_credentials - Optional credentials for accessing cloud storage
• csv_format - Optional configuration for CSV format

Returns:

A SQL string containing the COPY command