Help Center
Go back to application
Help Center
Go back to application
Getting Started
Navigating Talosix PlatformContacting our Customer Service
Study Management
HomeAI Patient IDCommentsQuery ManagementAdverse EventsProtocol DeviationConcomitant MedicationData Export
Data Management
Patient Management
Delegation of Authority
Analytics
Analytics Navigation Guide
Hands-On Analytics Guide
Create a ChartUse Chart BuilderCreate a DashboardEdit Dashboard PropertiesCreate DatasetsSQL LabShare Dashboard to Your Partners (Sponsors)
Account Settings
Access User SettingsChange Your Password Change Phone Number
Account Security
Admin Tools
Create New StudyManage SiteAssign Forms to Cohorts/TreatmentsManage FormsMigrate Study Settings and FormsManage Physician SurveyView and Manage Users
Study Settings
Data Import
eCRF Wizard

SQL Lab

SQL Lab is a powerful tool within Analytics Suite that allows you to interactively explore your data using SQL queries. his user guide will walk you through the key features and functionalities of SQL Lab, helping you harness its full potential.
  1. Accessing SQL Lab: Navigate to the "SQL Lab" page from the menu. Once you're in SQL Lab, you're ready to start querying your data!
  2. Writing SQL Queries: 
    • Write your SQL query in the provided text area. You can use SQL syntax to manipulate and retrieve data from your datasets.
    • You can select a table from the "See Table Schema" list to see its columns, data type and data sample.
  3. Running Queries: After writing your SQL query, click on the "Run Query" button, and SQL Lab will execute your query against the connected database.
  4. Viewing Results: Once your query is executed, you can view the results in the results table below the query editor.
  5. Saving Queries: If you want to save your query for future use:
    1. Click on the "Save" button.
    2. Provide a name and description for your query.
    3. Click "Save" to store the query in SQL Lab.

6. Visualizing Results: SQL Lab allows you to visualize query results for better insights. After running a query, click on the "Create Chart" button. This will open the Chart Builder page for your exploration.

 

Powered by Product Fruits