- Видео 43
- Просмотров 340 414
Datalytyx
Добавлен 20 ноя 2014
Welcome to the RUclips channel for Mphasis Datalytyx, a leading provider of big data engineering, data analytics and cloud solutions. Our RUclips channel is the go-to place for solution demonstrations, showcases and introductory videos to our business.
You can explore our website now for more information: www.datalytyx.com
You can explore our website now for more information: www.datalytyx.com
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...
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
99% of your data is worthless, but which 99%
Просмотров 1455 лет назад
99% of your data is worthless, but which 99%
Data driven strategy from a corporate perspective
Просмотров 1546 лет назад
Data driven strategy from a corporate perspective
Merry Christmas & A Happy New Year! From The Datalytyx Team
Просмотров 268 лет назад
Merry Christmas & A Happy New Year! From The Datalytyx Team
I signed up for a free trial, and my snowflake UI looks completely different than hers...
yes, It's a new UI now
Thanks for the definition of "work sh*ts"! Much appreciated 😅
Excellent job
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.
Who forced this guy to do the tutorial at gun point?
where can i find the queries to execute (in text) for pratice ?
It's a MySQL backend.
good
How to get access to this S3 bucket?
Thanks for the quick introduction.
very clear and useful. Salome fantastic!
Sorry, This presentation did not work or me, the um and ah & searching for words .
Thanks a lot for sharing this session.
Very informative.
Thank you for sharing this introduction about Snowlake! Your presentation is precise and clear.
how can one know the URL?
Spot on - just what I needed! Thank you
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
Which part are you missing?
Great video, thanks for sharing. Looks like I need to learn some SQL.
Dude!! You legend. I had this problem on a Ruby on Rails app and it totally fixed it for on that also. Thank you.
Why my Free Trial does not look like as mentioned in your video. Mine says Worksheet/Dashboard/Data/Marketplace......
why am I getting a feeling that like Cricket Commentary? anyway.. Indian perspective... :D
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.
😎
😎
correct comand to load the data is : copy into trips from @citibike_trips file_format=CSV PATTERN = '.*\.csv\.gz$' ON_ERROR = SKIP_FILE ;
totally worked
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
Very useful. Thank you Salome!
Big thanks!
C'mon Snowflake - get some better interesting data sets for these demos, PLEASE
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.
sad to hear such a generic statement about British people … otherwise agree
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????
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
This it works for me copy into trips from @citibike_trips FILE_FORMAT = (TYPE = CSV) ON_ERROR = 'CONTINUE';
thanks!
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
16:56 SCREEN CONTENT OR LETTERS ARE NOT VISIBLE. UPLOAD AGAIN WITH NEARER VIEW OF SCREEN CONTENT
The Citibike data was found in the aws public url, just follow everything she said to load the data.
Just reading reading reading !
I did this LAB successfully. with new UI-snowlight.
where did you find the required data ( the city bike csv files and the json files) to complete tge lab.
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
try to use this command, copy into trips from @citibike_trips file_format=CSV PATTERN = '.*\.csv\.gz$' ON_ERROR = SKIP_FILE ;
Where can I get Weather data JSON FILE???
Where can I find citibike data csv file? please..
Very good information 👍
What data modeling method do you use for this database: 3nf, dim, data vault,?
Thank you so much, all the information bundled into 90 minutes.
Datalytyx - Can you please share the sql scripts. Would help out a lot
Lots of information, Very much useful & Informative! Thanks
Great video. Can you make a video to understand the query execution plan and using it to improve query performance?
Good overview for the beginners 👍
Is this still an option? If so, who could I request more information from?
Really great informative video.