Snowpark Python: Ingest JSON Data Automatically In Snowflake

سرفصل های دوره

Automate DDL & DML SQL Generation For JSON Data Files & Save 95% Manual Effort

1. How JSON Data Files Are Processed In Snowflake

1. Challenges With JSON Data Onboarding & Processing Using DDLDML

2. JSON Data To DDLDML Automation Scope In Snowflake

2. JSON Data Processing Automation Requirement

1. Technical Pre-Requisite For This Course

2. What Would Not Be Covered In This Course

3. How Much DDLDML To Be Produced To Ingest Data

1.1 approach-1.zip

1.2 in-scope-out-of-scope.zip

1.3 order-item-data-flow.zip

1.4 order.zip

1. Amount of SQL Code (DDLDML) Required - Manual Effort Requirement

2.1 approach-2.zip

2. Approach-2 Where SnowPipe Is Used To Copy Data

4. Tree Map

1.1 course-tree-map.zip

1. Complete Course Structure Discussion

5. JSON Data File & Role Of Infer-Schema

1.1 emp json with array.zip

1.2 emp json with comma.zip

1.3 emp json with dic.zip

1.4 emp json with newline.zip

1.5 infer-schema-json.zip

1.6 simple emp single entity.zip

1. The Power & Limitation Of Infer Schema When Using With JSON Files

6. Creating Objects In Snowflake

1.1 user-role-etc.zip

1. Creating User & Role

2. Creating Database & Schema

3. Creating File Format & Stages

4.1 employee data.zip

4. Uploading JSON Data Using Snowsight

5.1 employee data cli.zip

5. Uploading JSON Data Using SnowSQL

7. Setting Up Python Version Environment

1. Setup Python Environment

8. Authentication

1.1 simple-auth.zip

1. SnowparkSnowflake Connectivity Using Basic Authentication

2.1 rsa-key-based-auth-snowpark.zip

2. SnowparkSnowflake Key Pair (RSA) Based Authentication

3.1 sso-based-authentication-snowpark.zip

3. SnowparkSnowflake Single Sign On (SSO) Based Authentication

9. SnowparkSnowflake JSON Ingestion Automation

1.1 python-src.zip

1. Challenges With Infer Schema

2. Design Approach

3. High Level Code Explanation

4. Jijja Template Discussion

5. List JSON

6. Infer Schema Logic

7. Jinja Execution

8. SQL Execution

10. Section-05

1.1 employee-domain-data-10k.zip

1.2 python-src-code.zip

1.3 sql-output.zip

1. Multiple JSON Entities & Run Automation Script To Generate DDLDML

2. Final Comment

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy