is it possible store PDF or HTML content in snowflake.Please help us what is the best data type to store PDF or HTML data. How to retrieve that

Question

is it possible store PDF or HTML content in snowflake.Please help us what is the best data type to store PDF or HTML data. How to retrieve that

Answer 1

If you just want to store HTML or PDF for any technical reason, you can use binary date type which can store such files up to 8Mb size. However, you could not query binary date type directly in your query.

If you have to extract any information, you can use python CLI and use python libraries to extract additional information, but you can not use SQL to extract any information.

HTML can be saved as XML but you can try that as it has couple of limitation and not sure if XML parsing is available in GA or still preview.

Answer 2

Snowflake has new unstructured data storage and querying functionality now. You can store the PDF in a stage and use a directory table to view the file list within the stage. You can create scoped URL's, etc. to allow applications to render the PDF files, etc.