Jump to Content
iomete.com
Pricing
Blog
About us
Documentation
Discussions
iomete.com
Pricing
Blog
About us
Documentation
Discussions
Search
Documentation
Welcome to iomete docs!
The iomete Lakehouse Platform
Guides
How-to Sync Data From AWS S3 to iomete
How-to Sync Data From JDBC Sources
How-to Run Your First Spark Job
Iceberg Tables
Getting Started
DDL
Queries
Writes
Iceberg Procedures
Maintenance
DATA SOURCES
JDBC Sources
CSV Files
JSON Files
Parquet Files
ORC Files
Spark SQL Reference
DDL
Create Database
Alter Database
Drop Database
Create Table
Alter Table
Drop Table
Create View
Drop View
Writes
Truncate Table
Insert Into
Merge Into
Insert Overwrite
Queries
SELECT
Common Table Expression (CTE)
CLUSTER BY Clause
DISTRIBUTE BY Clause
GROUP BY Clause
HAVING Clause
Hints
Inline Table
File
JOIN
LIKE Predicate
LIMIT Clause
ORDER BY Clause
Set Operators
SORT BY Clause
Sampling Queries
Table-valued Functions (TVF)
Use Database
WHERE clause
Window Functions
CASE Clause
PIVOT Clause
LATERAL VIEW Clause
TRANSFORM
Auxiliary Statements
Cache
Column Types
Datetime Patterns
Identifiers
Operators
Literals
NULL Semantics
Functions
User Guide
SSO Login
Virtual Warehouses
Serverless Streams
User management
Access Policy Management
Serverless Spark Applications
Storage Integrations
Integrated BI
Private Docker Registry
Iomete Spark Jobs
Data Compaction Job
Query Scheduler Job
JDBC Sync Job
Kafka Streaming
File Streaming
LIBRARIES
Drivers
SQLAlchemy Driver
JDBC Driver
Sync JDBC Sources
BI - Apache Superset
Security
Public Dashboards
Administration guide
IAM Role For Data Lake Access
Staging area access
Iomete IP Addresses
Database Connection Options
MISC
DataGrip Warehouse Connection
DBT
iomete Profile
Serverless Streams
Suggest Edits
Updated 6 months ago
Did this page help you?
Yes
No
