Acquire operations

A new table, from no input table

• Unpack an archiveNot built yet

  Decompress or unpack zip, tar, gzip (1 variant with a page)

• Read from a databaseRuns as a SQL step

  Read from a relational or NoSQL database, warehouse or lake (3 variants with a page)

• Read a file of any formatRuns as a SQL step

  One reader that picks the format from the file

• Read a columnar fileRuns as a SQL step

  Read Parquet, ORC, Avro, Arrow, Iceberg, Delta (5 variants with a page)

• Read a CSV or delimited fileRuns as a SQL step

  Read CSV, TSV, fixed-width, other delimited text (4 variants with a page)

• Read a JSON fileRuns as a SQL step

  Read JSON, NDJSON (3 variants with a page)

• Read another file formatNot built yet

  Read any other file format (SAS, SPSS, Stata, PDF, YAML, logs) (11 variants with a page)

• Read a spreadsheetRuns as a SQL step

  Read Excel, ODS, Google Sheets (2 variants with a page)

• Read an XML or HTML fileRuns as a SQL step

  Read XML, HTML tables (1 variant with a page)

• List files and foldersRuns as a SQL step

  List directories, file metadata, file exists (4 variants with a page)

• Generate rowsRuns as a SQL step

  Generate rows: sequences, date ranges, constants, typed-in data (5 variants with a page)

• Fetch from the webNot built yet

  HTTP GET or POST, REST, SOAP, GraphQL, web scraping (6 variants with a page)

• Paste in a tableNot built yet

  Take a table from memory or the clipboard

• Fetch from cloud storageNot built yet

  List or fetch from S3, GCS, Azure Blob, HDFS, FTP, SFTP (1 variant with a page)

• Read from an application's APINot built yet

  Read from a SaaS application API