Skip to main content

Posts

Showing posts from August, 2020

How to create a simple table in snowflake with external data

Create a table in snowflake using external data Recently I needed to upload a data into snowflake as a table and perform some operations on it. Surprisingly as it is, I found that although I knew how to create a table in sql; I didn't know how to upload a data into snowflake. Obviously, I could have gone into internet to find out python libraries to solve this problem; i.e. access snowflake via a python session, then get the data and upload it in some probable template for tables. But it was a quick work and I wanted to do it fast. So I chose to upload it in a s3 data bucket and then create an empty table in snowflake; in which I would then put the data, pulling it into snowflake from s3. Now that is a nice and easy way to do; and let's see the exact procedure and how do we complete each of the parts. Upload the data into s3: Uploading data into s3 can be done again in two ways. The first one is to use a boto3 session and then upload the data into s3 via that boto session. If...

Summarization: an unsolved NLP task

Select Language Afrikaans Albanian Arabic Armenian Azerbaijani Basque Belarusian Bulgarian Catalan Chinese (Simplified) Chinese (Traditional) Croatian Czech Danish Dutch English Estonian Filipino Finnish French Galician Georgian German Greek Haitian Creole Hebrew Hindi Hungarian Icelandic Indonesian Irish Italian Japanese Korean Latvian Lithuanian Macedonian Malay Maltese Norwegian Persian Polish Portuguese Romanian Russian Serbian Slovak Slovenian Spanish Swahili Swedish Thai Turkish Ukrainian Urdu Vietnamese Welsh Yiddish Bengali Gujarati Marathi Nepali Punjabi Tamil Telugu S ummarization is one of the several core tasks which are there in NLP. We will discuss about basic theories of summarization in this post. Summarization is the process of summarizing a text into a small, concise and important copy. A summarization of a text is expected to be bearing all the key points, while maintaining a text flow and coherence; and all the sentences created should be meaningful. A...