Documentation
  • The Fundamental
  • ACTIVE SYNC
    • Data Ingestion
      • Data Tracking
        • API Key Management
        • Generate Tracking ID
        • Install tracking with Tag Manager
        • Install Tracking from the Console
        • Tracking Method on Website
      • Datasource
        • MySQL
        • PostgreSQL
        • MongoDB
        • Microsoft SQL Server
        • Shopify
        • CSV
        • Google Sheets
    • Data Ingestion API
      • Data Lake
        • File upload
        • Tracking API
      • Data Warehouse
        • Batch upload
        • CSV upload
        • Tracking API
      • Data Schema Warehouse API
    • Data Integrations
      • Manage your API Key
      • Get Data using API
  • ROCKET.BI
    • Introduction
    • Data Warehouse
      • Data Management
      • Ad-hoc Query
        • Measure Schema
        • Calculated Field
      • Query Analysis
      • Relationship
    • Row-level Security
    • Dashboard
      • Dashboard Filter
      • Chart Control
        • Tab Control
        • Single Choice
        • Multiple Choice
        • Dropdown Control
        • Slicer Control
        • Date Control
        • Input Control
      • Manage Dashboard
        • Relationship
        • View and Share
        • Select Main Date Filter
        • Boost
        • Settings
        • Add Chart
        • Add Tab
        • Add Text
    • Chart Builder
      • Chart Types
        • Pie Chart
        • Column Chart
        • Bar Chart
        • Line Chart
        • Line Stock Chart
        • Pareto Chart
        • Bubble Chart
        • Scatter Chart
        • Map Chart
        • Area Chart
        • KPI Chart
        • Lollipop Chart
        • Parliament Chart
        • Funnel Chart
        • Pyramid Chart
        • Gauge Chart
        • Bullet Graph Chart
        • Heat Map Chart
        • Word Cloud Chart
        • Tree Map Chart
        • Stacked Column Chart
        • Stacked Bar Chart
        • Sankey Chart
        • Spider Web Chart
        • Wind Rose Chart
        • Histogram Chart
        • Bell Curve Chart
        • Table Chart
        • Pivot Table Chart
      • Chart Settings
        • Zoom
        • Inner chart filter
      • Chart Filters
        • Tab Filter
        • Single Choice
        • Multiple Choice
        • Dropdown Filter
        • Slicer Filter
        • Date Filter
        • Input Filter
      • Right-click Settings
        • Change date function
        • Drill down
        • Drill through
        • Use as a filter
    • SQL Query
      • Syntax
      • Functions
      • Aggregate Functions
      • Data Types
  • UNLOCK.CI
    • Unlock.CI
Powered by GitBook
On this page
  • Create a database
  • View database
  • Table in database
  • Table Schema
  • Table Data
  • Measure Schema
  • Calculated Filed
  • RLS
  • Create new table
  • Actions
  1. ROCKET.BI
  2. Data Warehouse

Ad-hoc Query

To explore data & quickly build the visualization. There are also supported functions & autocompletion for SQL query.

PreviousData ManagementNextMeasure Schema

Last updated 1 year ago

Create a database

1. To create a database, click the adding button

2. Type the database name, then click Create

View database

When clicking the name of the database you want to view, tables contained in the database will be shown with information about the owner and the created time. You can rename or remove it by clicking the action buttons.

Table in database

Table Schema

Click Edit to change the display name, data type, write a description, add the default value to the data, or enable Encryption. You can also add a new column to the table.

Table Data

Data from each column will be shown here.

Measure Schema

Calculated Filed

RLS

Create new table

  1. To create a new table, click New table

2. Input table name, then click Create

Actions

You can add people and groups to share the database and delete the selected database.

After clicking the table name, you can access the Table Schema, Table Data, Measure Schema, and Calculated Field. Click Action to , or delete table.

Data from measurement will be shown here. See more:

Data from calculation will be shown here. See more:

Your created RLS will be shown here. See more:

query table
Measure Schema
Calculated Field
Row-level Security