HDFSJTdCJTIydGl0bGUlMjIlM0ElMjJIREZTJTIyJTdE

From the Toolbox, click Files.
Click the Actions menu ( ⋮ ), choose Add File.
Select the Connection from the list.
Select the Input Type: HDFS.
Select the file. Click the ... to navigate to the file.
Specify the File Type such as Character Separated Values, Parquet, or Sequence.
Click the File Properties link to specify properties.
1. Provide the line separator, field separator, escape characters, enclosed by, skip top lines, and encoding type options according to your file type.
  See the Registered file settings table section for details.
2. For Compression, select None or LZO.
3. If the data includes header information, select Contains Header Row so that the column headings will not be included as part of the data.
4. Select Ignore Empty Rows to have empty rows ignored.
5. Select Key as Column to set the field name to be the column description or select Filename as column to set the file name to the column description.
Click Apply.
To use this file for lookup purposes, select the Lookup file checkbox. See Using lookup to learn more.
Click Refresh to view the columns on the right.
Specify whether the file is a Dimension or Fact.
If the source data contains primary key or foreign key, the system automatically marks it.
When you choose to view the Column List, you can sort, filter, and set Column Properties as needed. See the rest of this topic to learn more.
Choose Preview Table to see sample data and set up a filter. See the rest of this topic to learn more.
Click Save when you are finished. You can click Revert if needed.

TableJTdCJTIydGl0bGUlMjIlM0ElMjJUYWJsZSUyMiU3RA==

From the Toolbox, click Files.
Click the Actions menu ( ⋮ ), choose Add File.
Select the Connection from the list.
Select the Input type: Table.
Select the Table database followed by a table.
Or, enter a term into the Search box to quickly navigate to the file.
To use this file for lookup purposes, select the Lookup file checkbox. See Using lookup to learn more.
Click Refresh to view the columns.
Specify whether the file is a Dimension or Fact.
If the source data contains primary key or foreign key, the system automatically marks it.
When you choose to view the Column List, you can sort, filter, and set Column Properties as needed. See the rest of this topic to learn more.
Choose Preview Table to see sample data and set up a filter. See the rest of this topic to learn more.
Click Save when you are finished. You can click Revert if needed.

For Azure SQL DB Connection

If you are working with Azure SQL database connection, select an appropriate column to define the Spark partitions. A partition column enables distributed data reading during the cube build based on a range of values of the selected column. The column data type should be either number or date. For example, choose the column which is used as distribution key and sort key. Choosing an appropriate partition column greatly impacts the cube build time.
If you don't choose a partition column, Kyvos automatically chooses the first number column and uses it to define how Spark partitioning should be performed.

:note:atlassian-note#DEEBFF

Note

In Azure SQL Database, make sure that the fact tables with high data volume should have partitioning on the table column which is used in the Partition column option of the Kyvos register file.

HCatalogJTdCJTIydGl0bGUlMjIlM0ElMjJIQ2F0YWxvZyUyMiU3RA==

From the Toolbox, click Files.
Click the Actions menu ( ⋮ ), choose Add File.
Select the Connection from the list.
Set Input Type to Table.
Select the HCatalog database followed by a table.
Or, enter a term into the Search box to quickly navigate to the file.
To use this file for lookup purposes, select the Lookup file checkbox. See Using lookup to learn more.
Click Refresh to view the columns.
Specify whether the file is a Dimension or Fact.
If the source data contains primary key or foreign key, the system automatically marks it.
When you choose to view the Column List, you can sort, filter, and set Column Properties as needed. See the rest of this topic to learn more.
Choose Preview Table to see sample data and set up a filter. See the rest of this topic to learn more.
Click Save when you are finished. You can click Revert if needed.

Browser not supported