Data Warehouse
The Data Warehouse section of Skyone Studio is dedicated to storing and manipulating tabular data, using SQL as the foundation for queries and transformations.
This environment is ideal for both quick tests and in-depth analysis. For example: extracting customers who made purchases in the last 30 days.
How to access
You can access the Data Warehouse in two ways:
From the top menu: In any area of Skyone Studio, click the Data Warehouse option in the upper-right corner of the screen.
From the left sidebar: While navigating within Skyone Studio (except on the Studio Home screen), use the left-hand menu and select Data Warehouse.
Data Warehouse Options
The menu in the upper-right corner provides the following actions:
Create new Job: Automatically creates a new Job, which will open in a new tab.
Execute current Job: Runs the active Job in the current tab, processing the defined queries.
Execute current Job in new tab: Opens a new tab to run the same Job.
Job Process List: Displays all running processes.
Job Configuration: Allows you to configure parameters for the current Job. Settings are organized into two tabs:
General: Define the Job name and select the desired database (which must be previously registered).
Groups: Manage access permissions by adding or removing groups as needed.
Finally, click "Apply to save the settings.
Save Job: Saves the current state of the Job.
Returned Data Panel
After selecting or running a Job in the Data Warehouse, the Returned Data Panel section displays three distinct tabs with information related to data execution and structure:
In this tab, you can view the files available in the selected directory or file filter. It's the starting point to understand which data is being used as input.
Last updated