Quora on Snowflake Data Marketplace
The Quora Data Program is now available via the Snowflake Data Marketplace. Here are some example Snowflake queries from our Automotive dataset which surface popular and relevant content.
Example 1
TITLE
What were the most-viewed Quora questions about Tesla in 2020? |
DESCRIPTION (Optional)
Retrieves any questions with “Tesla” in the title, using a case-insensitive search, that were published in the year 2020, ordered by descending view count. |
QUERY
select * from quora_automotive_questions |
Example 2
TITLE
What were the most-answered questions in the Cars & Automobiles topic overall in 2020? |
DESCRIPTION (Optional)
Returns the 10 questions with the highest answer count. |
QUERY
select * from quora_automotive_questions |
Example 3
TITLE
What are the most-answered questions about Electric Vehicles on Quora? |
DESCRIPTION (Optional)
Returns questions tagged with Quora’s “Electric Vehicles” topic, ordered by answer count. |
QUERY
select * from question_topics |
Data Dictionary
Below is the data dictionary for Quora on the Snowflake Data Marketplace.
Element or Attribute Name | Description |
|---|---|
Id | Unique ID of the quora |
QuestionId | Unique ID of the question |
AnswerId | Unique ID of the answer |
CommentId | Unique ID of the comment |
Published | The date/time the question/answer/comment was published. |
Inserted | The date/time the review was inserted into the BoardReader database (GMT) |
Title | The question title |
Content | The body of the answer/comment |
Type | Type of the post. Possible values: 'question', 'answer', 'comment' |
CreationTime | The date/time the question/answer/comment was created. |
Language | The language of the question/answer/comment text |
Url | Url of the question/answer/comment |
Topics | Where available, list of the topics |
Topics/Topic/TopicId | ID of the topics |
Topics/Topic/TopicUrl | URL of the topics |
Topics/Topic/TopicName | Name of the topics |
Topics/Topic/Type | Type of the topics |
Author/UserId | Where available, ID of the author |
Author/UserName | Where available, Name of the author |
Author/UserProfileUrl | Where available, profile url of the author |
Author/ProfileImgUrl | Where available, profile image url of the author |
Author/ShortBio | Where available, short bio of the author |
Author/AllWorkCredentials | Where available, work credentials of the author |
Author/AllSchoolCredentials | Where available, school credentials of the author |
Author/LanguageCredentials | Where available, language credentials of the author |
Author/Location | Where available, location of the author |
Author/KnowsAbout/TopicId | Where available, ID of the topic |
Author/KnowsAbout/AnswerCount | Where available, answer count |
Author/KnowsAbout/Type | Where available, type |
Author/KnowsAbout/TopicUrl | Where available, URL of the topic |
Author/KnowsAbout/TopicName | Where available, name of the topic |
Author/TopicCredentials/TopicId | Where available, ID of the topic |
Author/TopicCredentials/Credential | Where available, credential of the topic |
Author/TopicCredentials/Type | Where available, type of the topic |
Author/TopicCredentials/TopicUrl | Where available, URL of the topic |
Author/TopicCredentials/TopicName | Where available, name of the topic |
ViewCount | question/answer view count |
ShareCount | answer share count |
CommentCount | answer comment count |
UpvoteCount | answer/comment upvote count |
FollowCount | question follow count |
AnswerCount | question answer count |