Skip to content

Snowflake and database field #686

@ppo-corp

Description

@ppo-corp

Feature Description

In Snowflake, tables fully qualified names are database_name.schema_name.table_name.

I would like to be able to use the same Snowflake connection in my env.yaml file to load tables into different databases.

Currently, I am forced to duplicate my Snowflake connections because the database parameter is mandatory and --tgt-object does not support the database_name.schema_name.table_name format, but only schema_name.table_name (in fact, if we use the database_name.schema_name.table_name format, the database name is ignored)

Desired changes:

  • Make the database parameter for Snowflake connections optional.
  • Manage a target object in the form database_name.schema_name.table_name

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions