Datalytyx
Datalytyx
  • Видео 43
  • Просмотров 340 414
Zero to Snowflake in 58 minutes
In this video, we'll walk you through the 'Getting Started with Snowflake - Zero to Snowflake' entry-level guide in only 58 minutes.
Salome will demonstrate how easy it is to
*prepare your lab environment
*load data
*run queries
*clone data
*work with semi-structured data
*time travel *set up role-based access controls
*get data from the Data Marketplace
*and reset your environment
They say it will take 90 minutes, but she'll get this done in 58.
You can follow along using your own Snowflake trial by using Snowflake's full guide available here: quickstarts.snowflake.com/guide/getting_started_with_snowflake/index.html#0
If you want to get started with Snowflake and need some guidance, schedule time wi...
Просмотров: 124 288

Видео

Snowflake announces Snowpark native support for Python - our hot take
Просмотров 1,7 тыс.3 года назад
Snowflake has made, what we think, is an underrated announcement on their Snowday event on 16 November - Native support for Python in Snowpark. www.snowflake.com/blog/snowday-python-comes-to-snowpark/ Since Snowpark's announcement last year, people have been clamouring for Python support - and now it's coming! Here's a hot take from Sunny Sharma, Senior Snowflake Consultant at Mphasis Datalytyx...
OneWeb builds a Snowflake Data Sharing Hub in only 6 weeks
Просмотров 1573 года назад
OneWeb, the global satellite communications company, engaged with Snowflake, DataOps.Live and Mphasis Datalytyx to allow their experts to supply and consume data between departments, effectively creating a Data Sharing Hub. In these interview excerpts, David Bath, VP Platforms at OneWeb, explains how quickly they were able to achieve results by infusing the extra capability of Mphasis Datalytyx...
How Stonegate turned data chaos to data clarity during lockdown
Просмотров 1783 года назад
Before the 1st 2020 COVID lockdown, Stongegate Pub Company engaged with Mphasis Datalytyx, Talend and Snowflake on a project to bring their analytics in-house from a third-party provider. After lockdown began, they turned up the speed on the project in order to prepare for the lifting of lockdown and make the most of the short window of time that pubs could be open. In this session at Big Data ...
DataOps Platform Demo
Просмотров 1,4 тыс.3 года назад
Insurance data being ingested, transformed and pushed out into a PowerBI Dashboard using Talend and DataOps.
Lunar Recon with NASA Scientist, Noah Petro
Просмотров 593 года назад
At Mphasis Datalytyx we have a regular weekly meeting where someone will present a technical solution or process to the rest of the company. It's a good learning and team-bonding exercise. This week we were fortunate enough to have a guest speaker, Noah Petro, Research Space Scientist at NASA's Goddard Space Flight Center. Noah is an expert in Lunar Reconnaissance and Lunar Geology and tells us...
Modernizing Your Data with DataOps - Key Moments
Просмотров 2863 года назад
This conversation had so many great moments. Here are some of the key points that we wanted to highlight. Jump to a section using the links below... This panel features... Michele, Goetz, VP, Forrester Mike Penrose, Practice Lead, Mphasis Datalytyx Frank Thomas, Head of EMEA Channel, Talend Tony Young, Senior Manager of Technology and Cloud, Snowflake Baz Javanshiri, Director of Financial Plann...
Making Mars Proof Parachute Material with Peter Hill, Director-Woven Fabrics, Heathcoat Fabrics
Просмотров 2693 года назад
At Mphasis Datalytyx we have a regular weekly meeting where someone will present a technical solution or process to the rest of the company. It's a good learning and team-bonding exercise. This week we were fortunate enough to have a guest speaker, Peter Hill, Director-Woven Fabrics of Heathcoat Fabrics. Heathcoat designed and manufactured the material that was used in the parachutes for the Ma...
Preparing for pubs reopening with data
Просмотров 413 года назад
Mphasis Datalytyx helped Stonegate Pub Company bring their analytics in-house so that they could monitor pub performance by hour and maximize profit during the brief lifting of lockdown. www.datalytyx.com/project/stonegate-pub-company/
Modernising Your Data Warehouse in 24 Hours
Просмотров 2704 года назад
Palladium is an end-to-end cloud data platform leveraging Snowflake, Talend and Databricks. It's available as a monthly subscription and can be 'switched on' in less than 24 hours.
Data Modelling Live at Big Data London 2019
Просмотров 1024 года назад
Datalytyx CTO, Guy Adams, does live development to meet a stakeholder demand on stage at Big Data London 2019, showcasing how easy it is to create a development stream from a production data warehouse.
How does Gallium deliver 99% accuracy using 1% of the data?
Просмотров 464 года назад
Datalytyx CTO, Guy Adams, at the Internet of Manufacturing event in Farnborough, explains how Gallium reduces the amount of data necessary to get accurate information by intelligently classifying time-series data points. www.datalytyx.com/gallium/
Data Platform at the Speed of Customers
Просмотров 334 года назад
Datalytyx CTO, Guy Adams, demonstrates infrastructure as code for the easiest, fastest and most dev ops-friendly deployment.
Big Data London 2019 with Datalytyx
Просмотров 814 года назад
Datalytyx sponsored Big Data London for the 4th year in a row. As a founding sponsor, we've seen the show grow and grow, becoming the premier conference for data and analytics in the UK and Europe. We were proud to showcase our products, Gallium, our smart IoT data compression technology, and Palladium, our cloud-based platform for data and AI. Learn more at www.datalytyx.com
We ingest 100 DBs with 14,500 cols and 103,400,000 rows into a blank DW in 3 min - LIVE!
Просмотров 2035 лет назад
Datalytyx CTO, Guy Adams, ingests 100 databases with 103.4 million rows into a blank Snowflake data warehouse in 3 minutes LIVE at Big Data LDN 2019. Visit www.datalytyx.com to learn how you can ingest data from all of your sources (on-prem or cloud) faster than you thought was possible and get #betterdatafaster with Datalytyx. www.datalytyx.com
Model data in front of your stakeholders LIVE at Big Data LDN
Просмотров 515 лет назад
Model data in front of your stakeholders LIVE at Big Data LDN
99% of Your IoT Data is Worthless, But Which 99%? at Big Data London 2019
Просмотров 825 лет назад
99% of Your IoT Data is Worthless, But Which 99%? at Big Data London 2019
Datalytyx at Talend Connect 2019
Просмотров 1625 лет назад
Datalytyx at Talend Connect 2019
99% of your data is worthless, but which 99%
Просмотров 1455 лет назад
99% of your data is worthless, but which 99%
99% of your data is worthless
Просмотров 1415 лет назад
99% of your data is worthless
Data Lakes from Datalytyx
Просмотров 3776 лет назад
Data Lakes from Datalytyx
Zero to Snowflake in 90 minutes
Просмотров 203 тыс.6 лет назад
Zero to Snowflake in 90 minutes
Data driven strategy from a corporate perspective
Просмотров 1546 лет назад
Data driven strategy from a corporate perspective
Snowflake at the Gherkin
Просмотров 1866 лет назад
Snowflake at the Gherkin
ThoughtSpot for Retail
Просмотров 1,6 тыс.7 лет назад
ThoughtSpot for Retail
Merry Christmas & A Happy New Year! From The Datalytyx Team
Просмотров 268 лет назад
Merry Christmas & A Happy New Year! From The Datalytyx Team
Talend's #1 VAR Partner
Просмотров 1378 лет назад
Talend's #1 VAR Partner
Future of Big Data - BrightTalk
Просмотров 2768 лет назад
Future of Big Data - BrightTalk
The Data Lake
Просмотров 798 лет назад
The Data Lake
Workflow
Просмотров 1968 лет назад
Workflow

Комментарии

  • @TK-lv5ff
    @TK-lv5ff 29 дней назад

    I signed up for a free trial, and my snowflake UI looks completely different than hers...

  • @gm16180
    @gm16180 Месяц назад

    Thanks for the definition of "work sh*ts"! Much appreciated 😅

  • @chukwubrighton4059
    @chukwubrighton4059 3 месяца назад

    Excellent job

  • @arazipinhas3922
    @arazipinhas3922 4 месяца назад

    When introducing an application, it’s important to keep it simple and avoid jargon. Unfortunately, this presentation missed the mark. It seems that simplicity has become a lost art.

  • @sourabhch3044
    @sourabhch3044 4 месяца назад

    Who forced this guy to do the tutorial at gun point?

  • @mwarcademw
    @mwarcademw 7 месяцев назад

    where can i find the queries to execute (in text) for pratice ?

  • @RayZde
    @RayZde 8 месяцев назад

    It's a MySQL backend.

  • @skbhati199
    @skbhati199 9 месяцев назад

    good

  • @anishyapaul5189
    @anishyapaul5189 9 месяцев назад

    How to get access to this S3 bucket?

  • @shobhitbhatnagar9539
    @shobhitbhatnagar9539 10 месяцев назад

    Thanks for the quick introduction.

  • @TheGiulz76
    @TheGiulz76 11 месяцев назад

    very clear and useful. Salome fantastic!

  • @Powdermonkey99
    @Powdermonkey99 Год назад

    Sorry, This presentation did not work or me, the um and ah & searching for words .

  • @banamali143
    @banamali143 Год назад

    Thanks a lot for sharing this session.

  • @venkatesansharankumar5341
    @venkatesansharankumar5341 Год назад

    Very informative.

  • @buguannishi
    @buguannishi Год назад

    Thank you for sharing this introduction about Snowlake! Your presentation is precise and clear.

  • @fabianzamora1174
    @fabianzamora1174 Год назад

    how can one know the URL?

  • @ElaineSmith-w7m
    @ElaineSmith-w7m Год назад

    Spot on - just what I needed! Thank you

  • @anajawaid4424
    @anajawaid4424 Год назад

    I am trying my hands on snowflake for the first time and my user interface looks totally different to what you are showing here?, has there been any sort of update as it is a bit confusing to trace stuff in the new UI

  • @michealgabriel4692
    @michealgabriel4692 Год назад

    Great video, thanks for sharing. Looks like I need to learn some SQL.

  • @SIBUK
    @SIBUK Год назад

    Dude!! You legend. I had this problem on a Ruby on Rails app and it totally fixed it for on that also. Thank you.

  • @chaychsaeed
    @chaychsaeed Год назад

    Why my Free Trial does not look like as mentioned in your video. Mine says Worksheet/Dashboard/Data/Marketplace......

  • @hydtechietalks3607
    @hydtechietalks3607 Год назад

    why am I getting a feeling that like Cricket Commentary? anyway.. Indian perspective... :D

  • @user-eco2023
    @user-eco2023 Год назад

    Note on creating external stage: Make sure to include the final forward slash (/) at the end of the URL or you will encounter errors later when loading data from the bucket.

  • @Dreadwinner
    @Dreadwinner 2 года назад

    😎

  • @Dreadwinner
    @Dreadwinner 2 года назад

    😎

  • @tree2rhym
    @tree2rhym 2 года назад

    correct comand to load the data is : copy into trips from @citibike_trips file_format=CSV PATTERN = '.*\.csv\.gz$' ON_ERROR = SKIP_FILE ;

  • @vinodsagar2412
    @vinodsagar2412 2 года назад

    Amazing video !.. I am new to snowflake, saw many videos in youtube couldn't able to match there level , after seeing this video I am feeling even I can learn snowflake and level of confidence is getting higher, thanks a lot for you support.... wish you all the best , keep going

  • @Juan-Hdez
    @Juan-Hdez 2 года назад

    Very useful. Thank you Salome!

  • @yogeshgawali8974
    @yogeshgawali8974 2 года назад

    Big thanks!

  • @vio4jesus
    @vio4jesus 2 года назад

    C'mon Snowflake - get some better interesting data sets for these demos, PLEASE

  • @kal_jorEl
    @kal_jorEl 2 года назад

    Thank you so much for this video. It was very well made. British people make some of the best tutorial videos. Learnt a lot from this video.

    • @20steve12
      @20steve12 Год назад

      sad to hear such a generic statement about British people … otherwise agree

  • @privateaccount896
    @privateaccount896 2 года назад

    Hi, By getting the file with the Stage like in the Video, i Receive a file, which includes csv, json and parquet datasets. This is making a Problem singe the Stage is using the file format which is csv….does anyone know, Why the dataset is not only csv or does someone had the same issue????

    • @privateaccount896
      @privateaccount896 2 года назад

      For anyone, who is having the same Issue, i found the solution: When you Import from the Worksheet, you need to add: copy into trips from @citibike_trips file_format=CSV ON_ERROR = CONTINUE

    • @luisalejandro4131
      @luisalejandro4131 20 дней назад

      This it works for me copy into trips from @citibike_trips FILE_FORMAT = (TYPE = CSV) ON_ERROR = 'CONTINUE';

  • @ExcelTutorials1
    @ExcelTutorials1 2 года назад

    thanks!

  • @gantafamily
    @gantafamily 2 года назад

    Hi, When I am trying to load staged file it is giving me this error: Number of columns in file (1) does not match that of the corresponding table (16), use file format option error_on_column_count_mismatch=false to ignore this error File 'citibike-trips-parquet/2013/06/03/data_01a19496-0601-8b21-003d-9b03003c624a_2106_4_0.snappy.parquet', line 2, character 1 Row 1 starts at line 1, column "TRIPS"["TRIPDURATION":1] If you would like to continue loading when an error is encountered, use other values such as 'SKIP_FILE' or 'CONTINUE' for the ON_ERROR option. For more information on loading options, please run 'info loading_data' in a SQL client. Can someone please help me to resolve this error. Thanks

  • @usefulent9257
    @usefulent9257 2 года назад

    16:56 SCREEN CONTENT OR LETTERS ARE NOT VISIBLE. UPLOAD AGAIN WITH NEARER VIEW OF SCREEN CONTENT

  • @mw7365
    @mw7365 2 года назад

    The Citibike data was found in the aws public url, just follow everything she said to load the data.

  • @sarthakkhore8012
    @sarthakkhore8012 2 года назад

    Just reading reading reading !

  • @webcloudcoding9034
    @webcloudcoding9034 2 года назад

    I did this LAB successfully. with new UI-snowlight.

    • @sakumalla158
      @sakumalla158 2 года назад

      where did you find the required data ( the city bike csv files and the json files) to complete tge lab.

  • @webcloudcoding9034
    @webcloudcoding9034 2 года назад

    Loading data>.not working>showing the error Found character '\u0006' instead of field delimiter ',' File 'citibike-trips-parquet/2013/06/05/data_01a19496-0601-8b21-003d-9b03003c624a_206_2_0.snappy.parquet', line 323, character 593 Row 323, column "TRIPS"["START_STATION_ID":4] If you would like to continue loading when an error is encountered, use other values such as 'SKIP_FILE' or 'CONTINUE' for the ON_ERROR option. For more information on loading options, please run 'info loading_data' in a SQL client. please help

    • @anishyapaul5189
      @anishyapaul5189 9 месяцев назад

      try to use this command, copy into trips from @citibike_trips file_format=CSV PATTERN = '.*\.csv\.gz$' ON_ERROR = SKIP_FILE ;

  • @webcloudcoding9034
    @webcloudcoding9034 2 года назад

    Where can I get Weather data JSON FILE???

  • @webcloudcoding9034
    @webcloudcoding9034 2 года назад

    Where can I find citibike data csv file? please..

  • @manjunathmnm
    @manjunathmnm 2 года назад

    Very good information 👍

  • @botrrun9399
    @botrrun9399 2 года назад

    What data modeling method do you use for this database: 3nf, dim, data vault,?

  • @dheerajarora5
    @dheerajarora5 2 года назад

    Thank you so much, all the information bundled into 90 minutes.

  • @stevenpais5174
    @stevenpais5174 2 года назад

    Datalytyx - Can you please share the sql scripts. Would help out a lot

  • @bharatk212
    @bharatk212 3 года назад

    Lots of information, Very much useful & Informative! Thanks

  • @hardikkikani2119
    @hardikkikani2119 3 года назад

    Great video. Can you make a video to understand the query execution plan and using it to improve query performance?

  • @SinskariBoi3366three
    @SinskariBoi3366three 3 года назад

    Good overview for the beginners 👍

  • @JonSchwaderer
    @JonSchwaderer 3 года назад

    Is this still an option? If so, who could I request more information from?

  • @didierbouba1067
    @didierbouba1067 3 года назад

    Really great informative video.