Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

Table of Contents

Search

  1. Preface
  2. Introduction to Databricks Connector
  3. Connections for Databricks
  4. Mappings for Databricks
  5. Migrating a mapping
  6. SQL ELT with Databricks Connector
  7. Data type reference
  8. Troubleshooting

Databricks Connector

Databricks Connector

Functions with Databricks

Functions with Databricks

When you use
SQL ELT optimization
,
Data Integration
converts the expression in the transformation by determining equivalent functions in the database. If there is no equivalent function,
Data Integration
processes the transformation logic.
The following table summarizes the availability of SQL ELT functions that you can push to the Databricks database by using full or source
SQL ELT optimization
:
Function
Function
ABS()
MOD()
ADD_TO_DATE()
POWER()
ASCII()
RAND()
AVG()
REG_EXTRACT()
CEIL()
REG_MATCH()
CHR()
REG_REPLACE()
CONCAT()
REPLACESTR()
COS()
REPLACECHR()
COSH()
REVERSE()
COUNT()
ROUND(DATE)
CRC32()
ROUND(NUMBER)
DATE_COMPARE()
RPAD()
DATE_DIFF()
RTRIM()
DECODE()
SET_DATE_PART()
EXP()
SHA256()
FLOOR()
SIN()
GET_DATE_PART()
SINH()
GREATEST()
SQRT()
IIF()
STDDEV()
IN()
SUBSTR()
INDEXOF()
SUM()
INITCAP()
SYSDATE()
INSTR()
SYSTIMESTAMP()
IS_DATE()
TAN()
IS_NULL()
TANH()
IS_NUMBER()
TO_BIGINT
IS_SPACES()
TO_CHAR(DATE)
LAST()
TO_CHAR(NUMBER)
LAST_DAY()
TO_DATE()
LENGTH()
TO_DECIMAL()
LN()
TO_FLOAT()
LOWER()
TO_INTEGER()
LPAD()
TRUNC(DATE)
LTRIM()
TRUNC(NUMBER)
MAKE_DATE_TIME()
UPPER()
MAX()
VARIANCE()
MD5()
-
MIN()
-

0 COMMENTS

We’d like to hear from you!