SOURCE_JDBC

All functions > SOURCE > SOURCE_JDBC

Creates a JDBC connection to the given DSN

Signatures

Returns: JDBC source connection for online queries

SOURCE_JDBC(dsn: VARCHAR, [timeout: DECIMAL], tables: ARRAY<VARCHAR>) → JDBCSOURCE
sql
ParameterTypeRequiredDescription
dsnVARCHARYesData Source Name or JDBC connection string
timeoutDECIMALNoOptional connection timeout
tablesARRAY<VARCHAR>YesArray of table names to expose

Notes

  • Creates JDBC connection to online database (MySQL, Postgres, etc.)
  • Used for real-time feature serving
  • Connection pooled and reused across requests
  • Tables parameter limits accessible tables for security
  • Online-only restriction (for low-latency serving)
  • Used with EXTERNAL_VIEW for real-time lookups
Suggest changes to this page
Last update at: 2026/03/03 16:47:38
Last updated: 2026-03-03 16:48:19