What is Databricks File Store (DBFS Browser)
You can use File Store to upload data files of various formats, including CSV and other data files as well as save the outputs.
To access the file store, you simply go on catalog and then create table.
Here is a downloadable resource consisting of numerous files.
Let me unzip the folder. So here are the contents of the folder. So, we have a CSV file we have. A text file and we have Json files as well.
I’ll cover the different file types in the folder and provide resources so you can understand the different the different file types and formats.
So let me start by opening the country’s CSV files. In a CSV file, the values are separated by commas.
We also have a tab delimited file (countries.txt) here, it contains the same values, except for everything is separated with a tab, which is equivalent to four white spaces.
We also have data in JSON format too. So, this contains the same data as the country’s CSV file. JSON stands for JavaScript Object Notation. Each record is surrounded by curly braces.
There are two types of JSON files, single line & multi line JSON files, in single line file everything is displayed in a single line.