Tag: SQL
What is Seeds in dbt? How to load CSV files into your data warehouse using the dbt ?
Seeds are the CSV files in your dbt project. There will be a seed director , that dbt can load…
Explain how can you implement dynamic partitioning in Hive (automatically creating partition based on column value)
Dynamic partition in hive Where there are large number of partition values , then its…
How to insert from Non Partitioned table to Partitioned table in Hive?
You can insert data from Non Partitioned table to Partitioned table , in short , if you want to have…
How to create AWS Glue table where partitions have different columns?
There can be a condition where you can expect new column in JSON file regularly . There can be a…