Skip to content
This repository has been archived by the owner on Sep 23, 2024. It is now read-only.

Make pre-created FILE_FORMAT object optional #188

Open
aaronsteers opened this issue Jul 12, 2021 · 0 comments · May be fixed by #219
Open

Make pre-created FILE_FORMAT object optional #188

aaronsteers opened this issue Jul 12, 2021 · 0 comments · May be fixed by #219
Labels
enhancement New feature or request

Comments

@aaronsteers
Copy link

Is your feature request related to a problem? Please describe.

This is not a bug but would expedite and streamline adoption for new useres.

Describe the solution you'd like

By making FILE_FORMAT optional, we can default to an inline CSV file format and not require pre-creating a FILE_FORMAT object in Snowflake.

Describe alternatives you've considered

The alternative I'm aware of it to create the FILE_FORMAT object manually. This is not especially conducive to trainings and other processes where we want to minimize pre-work and prereqs.

Additional context

Sample code below uses an inline format expression as in the example from Snowflake's docs here.

COPY INTO <dest_table> (<col_list>)
FROM <stage>
FILE_FORMAT = (
    TYPE = CSV
    EMPTY_FIELD_AS_NULL = FALSE
    FIELD_OPTIONALLY_ENCLOSED_BY = '"'
)
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
enhancement New feature or request
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant