Getatlas Anqqbdpidh

deltaray

Stay updated on the status of all your company's support tickets.

Customer portal

Getting your data into Deltaray efficiently and accurately is crucial for successful data analysis and transformation.  Here are some best practices to optimize your data ingestion process.

 Start with clean and high-quality data.  

  Consider necessary transformations during the ingestion process.  

  If your data is constantly updated, consider incremental loading:

  Apply data governance principles during ingestion:

By following these best practices, you can ensure efficient, reliable, and high-quality data ingestion into Deltaray.

Tips and tricks for optimizing your data ingestion process in Deltaray.

Data Ingestion Best Practices

Deltaray empowers you to work with data from diverse sources, going beyond simple CSV files. You can directly connect to databases and APIs, bringing your information into Deltaray for seamless transformation and analysis.

 In Deltaray,  create a new project that will hold the data from your database connection.

  Within your project, navigate to the "Data Ingestion" section. 

 Choose the type of database you want to connect to (e.g., MySQL, PostgreSQL, MongoDB, etc.).

  Enter the necessary database connection information:

  Deltaray will attempt to connect to your database. Test the connection to ensure everything is set up correctly. 

  After a successful connection, Deltaray will display a list of tables available in your database. Select the tables you want to import. 

  Deltaray will automatically detect the schema of your chosen tables. You can adjust the data types of fields if needed. 

  Click "Create Datasets" to import your database tables into Deltaray.

 Begin by creating a new Deltaray project.

 Navigate to the "Data Ingestion" section within your project.

 Deltaray will test the connection to your API. Make sure you have the correct credentials and endpoint information. 

  Deltaray will preview data returned from your API request. 

  You can adjust the field types and names from the API data preview. 

  Once satisfied with the data preview and schema, click "Create Datasets" to import data from your API. 

Deltaray provides a flexible way to connect to various data sources, empowering you to harness the power of your data, regardless of where it resides.

Discover how to connect Deltaray to external databases and APIs for data ingestion.

Connecting to Databases and APIs

CSV (Comma-Separated Values) files are a common format for storing and sharing tabular data. Deltaray makes it easy to import your CSV data, allowing you to quickly begin analyzing and transforming your information. 

  Start by creating a new project in Deltaray to house your imported data. Give your project a descriptive name.

 Within your project, go to the "Data Ingestion" section.

 Select the "CSV File" option as your data source.

 Click the "Upload File" button and choose the CSV file you want to import.

 Deltaray will attempt to automatically detect the delimiter and encoding of your CSV file. However, you can adjust these settings if needed.

  Once the file is uploaded, Deltaray provides a preview of the data, allowing you to verify that it has been imported correctly.

  Deltaray offers options to automatically assign data types to each column in your CSV. You can manually change the data type if necessary.

  After reviewing the data preview and defining field types, click "Create Dataset" to import your CSV data into Deltaray. 

You can now access your imported data within your project and start using Deltaray's transformation and analysis features.

Learn to import your data from CSV files into Deltaray.