airflow.providers.google.cloud.transfers.oracle_to_gcs
¶
Module Contents¶
-
class
airflow.providers.google.cloud.transfers.oracle_to_gcs.
OracleToGCSOperator
(*, oracle_conn_id='oracle_default', ensure_utc=False, **kwargs)[source]¶ Bases:
airflow.providers.google.cloud.transfers.sql_to_gcs.BaseSQLToGCSOperator
Copy data from Oracle to Google Cloud Storage in JSON or CSV format.
See also
For more information on how to use this operator, take a look at the guide: OracleToGCSOperator
- Parameters
oracle_conn_id (str) -- Reference to a specific Oracle hook.
ensure_utc (bool) -- Ensure TIMESTAMP columns exported as UTC. If set to False, TIMESTAMP columns will be exported using the Oracle server's default timezone.
-
convert_type
(self, value, schema_type)[source]¶ Takes a value from Oracle db, and converts it to a value that's safe for JSON/Google Cloud Storage/BigQuery.
Datetimes are converted to UTC seconds.
Decimals are converted to floats.
Dates are converted to ISO formatted string if given schema_type is DATE, or UTC seconds otherwise.
Binary type fields are converted to integer if given schema_type is INTEGER, or encoded with base64 otherwise. Imported BYTES data must be base64-encoded according to BigQuery documentation: https://cloud.google.com/bigquery/data-types
- Parameters
value (Any) -- Oracle db column value
schema_type (str) -- BigQuery data type