SQL for CSV datasets.
Execute SQL with CSV datasets SQL is usually reserved for interacting with databases but in this video I show how you can use Databricks to run SQL queries against a CSV dataset. There are a few defaults that can make working with a CSV dataset problematic, like disabled schema infering and no heade...
Saved in:
| Format: | Video |
|---|---|
| Language: | English |
| Published: |
[Place of publication not identified] :
Pragmatic AI Solutions,
[2022]
|
| Edition: | [First edition]. |
| Subjects: | |
| Online Access: | CONNECT CONNECT |
| LEADER | 03467cgm a22006617i 4500 | ||
|---|---|---|---|
| 001 | in00006122170 | ||
| 006 | m o c | ||
| 007 | vz czazuu | ||
| 007 | cr cnannnuuuuu | ||
| 008 | 220426s2022 xx 008 o vleng d | ||
| 005 | 20220712155720.0 | ||
| 035 | |a 1WRLDSHRon1312657952 | ||
| 040 | |a ORMDA |b eng |e rda |e pn |c ORMDA |d OCLCO |d OCLCF | ||
| 024 | 8 | |a 50134VIDEOPAIML | |
| 035 | |a (OCoLC)1312657952 | ||
| 037 | |a 50134VIDEOPAIML |b O'Reilly Media | ||
| 050 | 4 | |a QA76.73.S67 | |
| 082 | 0 | 4 | |a 005.75/6 |2 23/eng/20220426 |
| 049 | |a TXMM | ||
| 245 | 0 | 0 | |a SQL for CSV datasets. |
| 250 | |a [First edition]. | ||
| 264 | 1 | |a [Place of publication not identified] : |b Pragmatic AI Solutions, |c [2022] | |
| 300 | |a 1 online resource (1 video file (8 min.)) : |b sound, color. | ||
| 306 | |a 000800 | ||
| 336 | |a two-dimensional moving image |b tdi |2 rdacontent | ||
| 337 | |a video |b v |2 rdamedia | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a other |b vz |2 rdacarrier | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 344 | |a digital |2 rdatr | ||
| 347 | |a video file |2 rdaft | ||
| 380 | |a Instructional films |2 lcgft | ||
| 511 | 0 | |a Noah Gift, presenter. | |
| 520 | |a Execute SQL with CSV datasets SQL is usually reserved for interacting with databases but in this video I show how you can use Databricks to run SQL queries against a CSV dataset. There are a few defaults that can make working with a CSV dataset problematic, like disabled schema infering and no headers. These are crucial when running SQL against the CSV since the defaults will treat every single value as a string. Although this video uses Azure Databricks, the same concepts should apply to any Databricks cluster. In this video you will learn: Uploading a CSV dataset to Databricks Create a Notebook to work with the CSV dataset Find potential pitfalls in default options for CSV and SQL Useful Resources Azure Databricks, Pandas, and Opendatasets Free Azure Certification for Students Learn Azure Databricks fundamentals Try Azure for Free Introduction to Azure Databricks. | ||
| 590 | |a O'Reilly Online Learning Platform: Academic Edition (SAML SSO Access) | ||
| 630 | 0 | 0 | |a Microsoft Azure SQL Database. |
| 630 | 0 | 7 | |a Microsoft Azure SQL Database. |2 fast |0 (OCoLC)fst01937996 |
| 650 | 0 | |a SQL (Computer program language) | |
| 655 | 2 | |a Webcast | |
| 655 | 7 | |a Instructional films. |2 fast |0 (OCoLC)fst01726236 | |
| 655 | 7 | |a Internet videos. |2 fast |0 (OCoLC)fst01750214 | |
| 655 | 7 | |a Nonfiction films. |2 fast |0 (OCoLC)fst01710269 | |
| 655 | 7 | |a Instructional films. |2 lcgft | |
| 655 | 7 | |a Nonfiction films. |2 lcgft | |
| 655 | 7 | |a Internet videos. |2 lcgft | |
| 655 | 7 | |a Films de formation. |2 rvmgf | |
| 655 | 7 | |a Films autres que de fiction. |2 rvmgf | |
| 655 | 7 | |a Vidéos sur Internet. |2 rvmgf | |
| 700 | 1 | |a Gift, Noah, |e presenter. | |
| 710 | 2 | |a Pragmatic AI Solutions (Firm), |e presenter. | |
| 730 | 0 | |a WORLDSHARE SUB RECORDS | |
| 856 | 4 | 0 | |u https://go.oreilly.com/middle-tennessee-state-university/library/view/-/50134VIDEOPAIML/?ar |z CONNECT |3 O'Reilly |t 0 |
| 949 | |a ho0 | ||
| 994 | |a 92 |b TXM | ||
| 998 | |a wi | ||
| 999 | f | f | |s 4ef70452-b663-49d0-b889-b48f663e9106 |i 4d72c45b-5420-4fef-8fca-fced2da62606 |t 0 |
| 952 | f | f | |a Middle Tennessee State University |b Main |c James E. Walker Library |d Electronic Resources |t 1 |e QA76.73.S67 |h Library of Congress classification |
| 856 | 4 | 0 | |3 O'Reilly |t 0 |u https://go.oreilly.com/middle-tennessee-state-university/library/view/-/50134VIDEOPAIML/?ar |z CONNECT |
