in managed-connectivity/sample-custom-connector/src/entry_builder.py [0:0]
def choose_metadata_type_udf(data_type: str):
"""Choose the metadata type based on Oracle native type."""
if data_type.startswith("NUMBER") or data_type in ["FLOAT", "LONG"]:
return "NUMBER"
if data_type.startswith("VARCHAR") or data_type.startswith("NVARCHAR2"):
return "STRING"
if data_type == "DATE":
return "DATETIME"
return "OTHER"