- 36
- 7 297
Tech Learning Hub
India
เข้าร่วมเมื่อ 25 ก.พ. 2024
what is index in Database tables how to disable & enable indexes ? @TechLearningHub-bs4sg
what is index in Database tables how to disable & enable indexes ? @TechLearningHub-bs4sg
มุมมอง: 155
วีดีโอ
what is view & why use view in Database @TechLearningHub-bs4sg
มุมมอง 1132 หลายเดือนก่อน
what is view & why use view in Database @TechLearningHub-bs4sg
How to explain project for data engineers in interview
มุมมอง 1813 หลายเดือนก่อน
@TechLearningHub-bs4sg th-cam.com/video/x-X-B3sqJZ0/w-d-xo.html
MySQL to snowflake data migration process.
มุมมอง 1633 หลายเดือนก่อน
MySQL to snowflake data migration process.
How to find first and last record in Snowflake tables ? @TechLearningHub-bs4sg
มุมมอง 2454 หลายเดือนก่อน
@TechLearningHub-bs4sg
what is stream in snowflake and how to query streaming object.
มุมมอง 2346 หลายเดือนก่อน
1. stream is a new Snowflake object type that provides change data capture (CDC) capabilities to track the delta of changes in a table, including inserts and data manipulation language (DML) changes, so action can be taken using the changed data. 2. A table stream allows you to query a table and consume a set of changes to a table, at the row level @TechLearningHub-bs4sg
How to create Snow pipe & continuously data loading from aws s3 to snowflake tables.
มุมมอง 2006 หลายเดือนก่อน
create or replace stage stage_pipe_customer url='s3://greenvillage/MAHI/' credentials=(AWS_KEY_ID ='AKIAU6GDX56BEUSMDNCY' AWS_SECRET_KEY ='ZyEJIOXM6yqgIp6AHUBFKJteW3ilfttniNgZIccf'); //Create a Snowpipe create or replace pipe s3pip auto_ingest = true as copy into emp from @stage_pipe_customer file_format=(format_name ='csvformat'); show pipes; LIST @stage_pipe_customer;
how to query last 5 records & first 5 records in a table
มุมมอง 2636 หลายเดือนก่อน
how to query last 5 records & first 5 records in a table
snowflake Roles and Responsibilities @TechLearningHub-bs4sg
มุมมอง 3166 หลายเดือนก่อน
@TechLearningHub-bs4sg SNOWFLAKE ROLES Account admin:( Top level) 1.Administer of the snowflake account 2.The role can view all billing information & credits 3. The another admin roles sysadmin security admin childrens of this roles Sysadmin : This role can create warehouses & databases and all objects with in a database Security Admin : 1.This role is designed to cater for the administration s...
How to Delete Duplicate records within a fraction of seconds @TechLearningHub-bs4sg
มุมมอง 1896 หลายเดือนก่อน
To delete Duplicate records within a fraction of seconds use the below query insert overwrite into TABLE_NAME select distinct * from TABLE_NAME; @TechLearningHub-bs4sg
How to create Snow pipe Event notification AWS s3 Bucket
มุมมอง 1537 หลายเดือนก่อน
How to create Snow pipe Event notification AWS s3 Bucket
what is snowpipe in snowflake & advantages of snowpipe, how to create snow[pipe.
มุมมอง 1427 หลายเดือนก่อน
@TechLearningHub-bs4sg Snowpipe Snowpipe is Snowflake continuous data ingestion service. It provides a pipeline for loading new data as soon as it is available, either in an internal or external stage. This is often referred to as continuous, or micro-batching, This means you can load data from files in micro-batches, making it available to users within minutes rather than manually executing CO...
what is cache concept in snowflake @TechLearningHub-bs4sg
มุมมอง 2167 หลายเดือนก่อน
@TechLearningHub-bs4sg Cache in Snowflake: We have cache mechanism in Snowflake to speed up query performance. We have different types of Cache available in Snowflake Metadata Cache Query Result Cache Warehouse Cache Metadata Cache: Metadata caching is maintained in Cloud Service Layer(metadata layer) Snowflake automatically collects and manages Metadata about Tables and micro-partitions Metada...
What is File Format Object & How to create File Format Object in SNOWFLAKE @TechLearningHub-bs4sg
มุมมอง 1937 หลายเดือนก่อน
@TechLearningHub-bs4sg create or replace file format json_file_format1 type = JSON; create or replace file format xml_file_format type = xml; create or replace file format avro_file_format type = avro; create or replace file format parquet_file_format type = parquet; create or replace file format csv_file_format type = csv; create or replace file format orc_file_format type = orc; show file for...
Pigeons Chennai Besant nagar Elliots beach every day morning. @TechLearningHub-bs4sg
มุมมอง 887 หลายเดือนก่อน
Pigeons Chennai Besant nagar Elliots beach every day morning. @TechLearningHub-bs4sg
Tables in Snowflake @TechLearningHub-bs4sg
มุมมอง 1487 หลายเดือนก่อน
Tables in Snowflake @TechLearningHub-bs4sg
What is Zero Copy Cloning in Snowflake .@TechLearningHub-bs4sg
มุมมอง 1687 หลายเดือนก่อน
What is Zero Copy Cloning in Snowflake .@TechLearningHub-bs4sg
How to Query and Run the files in AWS S3 Bucket.
มุมมอง 2087 หลายเดือนก่อน
How to Query and Run the files in AWS S3 Bucket.
1 LAKH RECORDS LOADING AWS S3 TO SNOWFLAKE TABLE
มุมมอง 3238 หลายเดือนก่อน
1 LAKH RECORDS LOADING AWS S3 TO SNOWFLAKE TABLE
How to get AWS access keys AWS KEY ID & AWS SECRETKEY KEY
มุมมอง 5018 หลายเดือนก่อน
How to get AWS access keys AWS KEY ID & AWS SECRETKEY KEY
How to upload files in S3 bucket in AWS
มุมมอง 1428 หลายเดือนก่อน
How to upload files in S3 bucket in AWS
Analytical Concepts Master data and Transactional Data:
มุมมอง 1758 หลายเดือนก่อน
Analytical Concepts Master data and Transactional Data:
Snow flake how to create warehouse using SQL
มุมมอง 1328 หลายเดือนก่อน
Snow flake how to create warehouse using SQL
Snowflake Standard scaling policy and Economy scaling policy
มุมมอง 1228 หลายเดือนก่อน
Snowflake Standard scaling policy and Economy scaling policy
Auto scale, Maximized, Scaling up, Scaling down, Scaling out, snapping back
มุมมอง 1838 หลายเดือนก่อน
Auto scale, Maximized, Scaling up, Scaling down, Scaling out, snapping back
Good bro
Hello bro card konsa lagega mujhe multiple accounts chahiye aws ke mere paas card 1 hai bs
Good
Excellent Explanation. All the best. 🎉
Thanks
Nice explanation
🎉
Good
Good topics bro
Good
Good information
Good
Good information
Bro I see lot of videos no one telling 1 lakh records loading external stage s3 to snowflake. Your are giving the good information. Thanks
Good
Good
Good Information
GOOD
good Explanation
good
Thanks for giving valuable information
Good
Good Topic’s
Good Explanation
Good bro
Good
Good explanation how to create snowflake trail account.
Good snowflakes topics
Good
Please continue other topis
Good explanation data warehouse.
Good information
Thanks
Good
Good information please continue the series.
Thank you, I will