Intelligent Object Connectors

Admins can upload and manage data easily in Nitro’s data lake using Intelligent Objects. Intelligent Objects are a type of inbound connector for file-based data. Intelligent Object connectors have three core components:

Advanced data lake connectivity to get the data onto the platform efficiently and securely
Automatic metadata detection and analysis that interrogates the data model and syncs it to Nitro’s core data model
Direct querying of the data enabling exploration of the file-based data immediately alongside the rest of data on the platform

The following connector types are available:

All data loaded into Intelligent Object Connectors are viewable as any other view(s) under the database report schemas of the connector, without having to create table definition files for them.

Intelligent Objects Connectors are defined with allow lists in the Nitro Admin Console. Intelligent Object Configurations in the NAC are sorted alphabetically by default.

If a data type mismatch error occurs when the job is run, select the Force all columns to be string check box.

Deleting Intelligent Objects from the NAC

Users can delete any custom Intelligent Object, Compass, or Link for Key People table from the NAC. Users do not need to log a Support ticket before loading an intelligent object table using the Nitro Admin Console.

To delete a table, select Delete from the appropriate table page to remove the data files, glue table, metadata, and views.

Considerations:

Large Parquet files supported (up to 20GB)
Only snappy compression is supported for parquet files
Escape character “\” supported
Compression for csv files can be .zip or .gz