What is your experience with getting data into Snowflake?
For this exercise, write a SQL query that summarizes ingestion activity by source system and load method. Return only source systems that have at least one successful load. Ignore rows where loaded_at is NULL.
source_system and load_methodsource_system, load_method, successful_loads, total_rows_loaded, last_loaded_atloaded_atsource_system ascending, then successful_loads descending, then load_method ascending| Column | Type | Description |
|---|---|---|
| event_idPK | INT | Unique ingestion event identifier |
| source_system | VARCHAR(100) | Upstream system name |
| load_method | VARCHAR(50) | Ingestion method used |
| load_status | VARCHAR(20) | Result of the ingestion attempt |
| rows_loaded | INT | Number of rows loaded in the event |
| loaded_at | TIMESTAMP | Timestamp when the load completed |