SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ33

VerifiedIngest and Process Data

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?

Explanation

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.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!