Skyone
English
English
  • Home
  • Skyone Platform
    • Overview
    • Access and Registration
      • Password recovery for the platform
    • Settings and Preferences
      • My Profile
      • User Management
        • How to invite a user to the platform?
        • Options for User Management
        • Types of User Permissions
      • Invitations
      • My Company
      • Support Case Configuration
      • Companies Management
      • Billing
      • Settings
      • Security
      • Feedback
      • Logs
      • Cancellation
      • Partner-Clients
        • My Clients
        • My Partner
    • Notification
    • Health: Platform status check
    • Support Cases
      • How to track and respond to support cases?
      • Guide for opening ABO Tickets
  • Cloud Computer
    • Overview
    • Autosky
      • Login and Password Registration
        • Password RecoveryPassword Registration
      • Profile and Preferences
      • Skyone Autosky Platform
        • Dashboard
        • Accounts
          • Servers
            • Server Options
        • Environments
          • Micro environment
            • Micro environment instance
            • Micro environment servers
          • Scaling environment
            • Scaling environment instances
            • Scaling environment servers
          • Other features of the environments
        • Clients
          • Edit and Clone
          • Users
          • Applications
          • Sessions
          • Manage Access Restrictions
          • Maintenance
            • Maintenance history
        • Users
    • Cloud Server
      • Cloud Server Options
      • Backup Audit
  • Studio
    • Overview
      • Create an account
      • Recover Password
      • Quick Platform Guide
      • How to test the platform for free
      • Workspace
        • Creating a new Workspace
        • Find a Workspace
        • Sending an invitation to a Workspace
        • Editing a Workspace
      • Organizations
        • Creating an Organization
        • Organization Overview
        • Organization Management
        • Organization Monitoring
      • Settings and Preferences
        • Profile
        • Notifications
        • Usage and Billing
        • Users and Permissions
    • Integrations
      • Integration Management
        • Create integration
        • Import Integration
        • Edit Integration
        • Integration Options
        • Flows of this integration
      • Flows
        • Flow management
          • Creating a flow
          • Flow options
          • Flow Canva: configuring and editing the flow
            • Flow Canva: overview
            • Exception Handler
              • Exception Handler - Configuration
              • Exception Handler - Cases
            • Multicontext Flows
              • Example: Multicontext with an API Gateway
              • Example: Multicontext with a Time Trigger
            • Flow Settings
        • Triggers of a flow
          • API Gateway Triggers: Adding and Setting
          • AS2 Triggers: Adding and Setting
          • Queue Triggers: Adding and Setting
          • Flow Triggers: Adding and Setting
          • Time Triggers: Adding and Setting
          • Webhook Triggers: Adding and Setting
        • Tool Modules
          • AS2 Module
          • CSV Module
          • Data Transform Module
          • Data Balancer Module
          • EDI Module
          • Flow Call Module
          • IF Module
          • JavaScript Module
          • Log Module
          • Loop Do While Module
          • Loop For Module
          • Return Module
          • XML Module
          • Other Tool Modules
        • Module Header
        • Connecting components of a flow
        • Editing triggers and modules
        • Data Operations
          • Object Handling
            • Practical example: Handling variables
          • SMOP (Small Operations)
          • Parameterization rules
    • Modules
      • Module management
        • Creating a Module
        • Importing a Module
          • IAC Files - Integration as Code
        • Editing a module
        • Module Options
      • Settings and Operations
        • Module settings
          • Connectivity: Database
          • Connectivity: Email
          • Connectivity: REST
          • Connectivity: SOAP
          • Connectivity: File
          • Connectivity: RFC
          • Connected Account Management
        • Operations
          • Importing operations into REST Modules
          • Operation Management
        • Flows Using This Module
    • API Gateway
    • Terminals & Agent
      • Agent
        • Versions supported by Agent
        • How to Update the Agent Version
        • How to back up Agent files
      • Terminals
    • Data Management
      • Engine
        • How to use the Data Engine Proxy
      • Parameters
      • File filters
      • File templates
      • File Jobs
      • JSONata Jobs
    • Data Lake
    • Data Warehouse
      • Data Jobs
      • Databases
    • Artificial Intelligence
    • How to
      • Insert JSON into databases
      • Flattening: Data transformation using JSONata
      • How to use Form Data
      • Understanding recursion in JSONata
      • REST Module Output Consolidation
      • How to configure a component timeout?
      • Isolated in execution: concept and application in variables
      • URL Parameters in API Gateway
      • Use case: API Gateway trigger parameters
      • Use case: Exception Handler in financial transactions
      • Use case: using Groups to manage access to flows
      • How to create a download endpoint and integrate with Power BI
      • Is it possible to use two triggers in a single flow?
    • FAQ
    • GIGS: The complete guide
    • Glossary
  • Cybersecurity
    • Overview
    • Threat Analysis
      • Security Panel
      • Targets
      • Schedules
      • Target Resolution
      • Threat Group
      • Report
    • How to install Bitdefender security agents
Powered by GitBook
On this page
  • Add a Data Job
  • Data Job Options:
  • Delete a Data Job
  1. Studio
  2. Data Warehouse

Data Jobs

"Data Jobs" is a feature that allows you to create and execute SQL queries to read, transform, and organize data within Skyone Studio. It’s ideal for automating data processing routines and preparing information for use in other workflows or analyses.

Add a Data Job

To add a new “Data Job”, follow these steps:

  1. In the left-hand menu, click “Data Jobs”.

  2. Then, click "Add Data Job".

  3. The edit screen for the new Data Job will be displayed automatically.

  4. Click "Job Configuration" to select the database.

  5. Click the "Save" icon to complete the creation.

Data Job 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 File 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.

Delete a Data Job

To delete a “Data Job”, follow these steps:

  1. Go to the “Data Job” section in the left-hand menu to view all created Data Jobs.

  2. Hover over the desired item and click the trash icon.

  3. Type the name of the Data Job and click "Delete" to confirm the action. Done! The Data Job has been deleted.

PreviousData WarehouseNextDatabases

Last updated 2 days ago