In this tutorial, you will learn:
How to access (slice) a public array
How to perform a SQL query on a public array.
How to perform serverless UDFs on a public array.
We will use public TileDB Cloud array TileDB-Inc/nyc_tlc_yellow_trip_data_2019, which stores the data from the NYC yellow taxi dataset for the year of 2019. The original data is in CSV format with collective size ~7GB, which is converted into a TileDB 1D sparse array with the size being compressed down to ~1GB. The selected sparse dimension is
tpep_pickup_datetime, which means that the array supports very fast range slicing on that column of the dataset.
You can run all the commands of this notebook in your own client. The only changes required are: