Table downloads, partitions and storage

Download the rows of a Warehouse table as a file, and read how much the table holds: its size, its row count and its partitions. Use this when you need the data outside DataMind, or when you want to check a table before you build on it.

Download a table

1. Open the table and go to Preview. Preview works on deployed tables; if the tab stays disabled, deploy the table first; see Preview table data.
2. In the toolbar, open the format button and choose Excel, CSV, JSON or TSV. The control itself is covered in Export and copy.
3. Click the download button. If the table holds more rows than the preview shows, the menu asks you to choose Export N rows or Export all N rows; N is the number of rows.
4. Your browser saves the file.

The file holds the columns the preview shows, in their order. A hidden column is not written, although filters and sorting may still use it. When no column selection is given, every column of the table is written.

Download formats and limits

• Excel downloads are real workbooks, with the data on one sheet named Data. An Excel file stops at 1,045,000 rows, and a larger table is refused with Excel supports up to 1,045,000 rows, this export has more. Use CSV, TSV or JSON instead.
• CSV downloads are not capped at 100,000 rows: a table with 100,500 rows downloads whole.
• If a download fails, DataMind shows Export failed and the reason; try again after fixing it.

Read a table's size, rows and partitions

A deployed table shows its storage figures in its Settings tab: Size, Rows and Partitions. A table that is not deployed yet has no figures to show.

• Size is the disk space the table uses.
• Rows is the number of rows the table holds.
• Partitions is how many partitions the table is split into.

Partitions are listed with their row counts. Counts are de-duplicated, so a row loaded more than once is not counted twice, and the counts together add up to the Rows figure. You see the list wherever partitions are picked, such as in Truncate Partitions for a dimension or fact, which shows each source system's partitions and the rows they hold; see Deploy, run, truncate and monitor tables.

Not every table is partitioned. Partitions come from a table's partition column, so a table without one has no partitions to list.

Reading the figures and downloading a table need View Warehouse Objects; see Warehouse permissions and row-level security. To speed up reads on a large table, add an index: see Table indexes.

Questions, answered

Is the CSV download capped at 100,000 rows?

No. A CSV download is not capped at 100,000 rows: a table with 100,500 rows downloads whole.

Why is my Excel download refused?

An Excel file stops at 1,045,000 rows. A larger table cannot be downloaded as Excel; DataMind shows Excel supports up to 1,045,000 rows, this export has more. Use CSV, TSV or JSON instead. Download it as CSV, JSON or TSV.

Can I download only some of the columns?

Yes. The file holds the columns the preview shows, in their order; a hidden column is not written, although filters and sorting may still use it. When no column selection is given, every column of the table is written.

Does the Excel file open as a normal workbook?

Yes. An Excel download is a real workbook, with the data on one sheet named Data.

Which tables show storage figures?

Dictionary, Dimension, Fact, Static and View tables show Size, Rows and Partitions on their Settings tab, once the table is deployed. A table that is not deployed yet has no figures to show.

Do the partition row counts add up to the Rows figure?

Yes. Counts are de-duplicated, so a row loaded more than once is not counted twice, and the counts together equal the Rows figure.

Can every table show partitions?

No. Partitions come from a table's partition column, so a table without one has no partitions to list.

Who can download a table or see its storage?

Someone with View Warehouse Objects, the same permission that opens the table and its preview. The full list is on Warehouse permissions and row-level security.