Loading Data in Snowflake
- Do you use transformation when loading data using the COPY command?
- What is needed to establish connectivity between snowflake and cloud storage ?
- How can we ingest data without using snowpipe, COPY or 3rd party ETL like DBT ?
- You received files from your new vendor, you are aware of the layout of ..?
- How will you setup a process of automatic validation and quality control of ..?
- Once a file is loaded with the COPY command can you reload the file again ?
- What is the data loading strategy in your project ?
- When ingesting data from data lake, are most of your files in parquet format ..?
Unloading Data from Snowflake
- What is data unloading ?
- When unloading data into cloud storage what best practices do you use ?
- Was there a scenario in your project where you had to unload the data to ..?
- Do you prefer unloading data into multiple files or single file from snowflake ?
- Can you unload data from multiple tables in a COPY command ?
- How are parquet files zipped when being unloaded ?
- How do we modify column data types when unloading data ?
- What problems have you encountered when unloading data ?
- How can you limit the size of a file generated by unloading data from snowflake
Hybrid Tables
- What is a Hybrid Table ? What are its main features ?
- What is Unistore and what does Hybrid tables have to do with Unistore ?
- How are Hybrid tables different from other table types like permanent table ?
- Is Snowflake Architecture different for Hybrid Tables ?
- Lab Exercise -Create Hybrid Tables and Insert Rows in them ?
Mock Interview
- Mock Interview Ravi(Interviewer) vs Sujith(Data Engineer)
Bonus Lecture
- Bonus
