- ...has successfully demonstrated an ability to use Snowflake to:UNI ID: 005VI00000AT25VYAT Snowflake Account: ZD16719 Badge ID: 110825805NOTE: Hands-On Badge Workshops allow learners to prove their ability to use Snowflake to carry out data-related tasks. They are NOT based on proctored certification exams. Both are valuable, but represent different types of experience and expertise.On July 30, 2024, with a full review of their lab work by DORA the grading robot...Simon GreenConvert Timezones with Snowflake Date/Time Data Types Map Approximate End User Locations via IP Addresses Create & Run SNOWFLAKE TASKS and MERGE Statements. Create a STREAM for Change Data Capture Functionality. Create a SNOWPIPE for Event-Driven, Continuous Loading.
Simon Green
Our Data Engineering Workshop (DNGW) teaches workshop participants about the role of Data Engineers in Data-Driven organizations and allows the learner to get hands on experience with date and time data types, tasks, pipes, merge statements, and more. This workshop is highly interactive with reflection questions, hands on lab work and automated lab work checks! Fast-paced and informative, light in tone, scenario-driven and metaphor rich.
Skills / Knowledge
- Timezones and Timestamp Formats
- CTAS
- Snowflake Streams/CDC
- Snowflake Tasks
- Parsing JSON with Paths and Casts
- Session Settings
- Query Profiles
- SQL Merge Statements
- Task History and Dependency
- Snowpipe Continuous Loading
- SQL Window Function
- Snowflake Dashboards
- Storing Metadata in Columns
- Advanced SQL
Issued on
July 30, 2024
Expires on
Does not expire