A Data Engineer must ingest invoice data in PDF format into Snowflake so the data can be queried and used in a forecasting solution.
What is the recommended method for ingesting this data?
PDF is unstructured data and is not a supported direct input format for standard COPY INTO loading or external tables. A Java UDF can use a staged Java PDF-parsing library, such as Apache PDFBox, to read staged PDF files and extract their contents into structured data that can be stored and queried in Snowflake.
COPY INTO
Community Discussion