Sheethal K S
Reputation: 1
Loading multiple file formats together in snowpipe
We have 2 types of file format 1. Xml and 2. Json. How can we load 2 types of files together to snowpipe?
Upvotes: 0
Views: 426
Answers (1)
Sergiu
Reputation: 4578
You can't load two different file formats on the same variant column on the same table using the same pipe.
You can create two different pipes and two tables and load the files based on a pattern to their respective table.
What are you trying to achieve using a single pipe?
Upvotes: 2
Related Questions
- Snowflake:Read all files with wildcard
- Dropping multiple file formats in Snowflake at once
- Can we use single snowpipe to load data from multiple source to multiple destination
- Snowpipe: loading only the first row
- Snowflake: how to load files through stage from MS Azure using specific pattern?
- Snowflake unloading structured data into semi- structured file format
- Snowflake unloading beaks file into too many small files
- loading a lot of small files into snowflake
- Creation of file-format in Snow-flake
- How to load a table with multiple zip files in Snowflake?