Questions tagged [data-explorer]
For questions about the functionalities, queries, databases and datamodel of The Stack Exchange Data Explorer (SEDE). SEDE allows you to create and run queries against copies of the databases of popular Stack Exchange sites.
1,622 questions
-2
votes
2
answers
126
views
Is there an AI for constructing data explorer queries?
I don't know the syntax of the language used for constructing Data Explorer queries. Short of learning it, I was wondering: Is there an AI interface that can take in a query in plain English and ...
- 122
2
votes
1
answer
58
views
How to modify an SEDE query for the Generalist badge to consider questions instead of answers
Puzzling Stack Exchange is considering implementing a "Generalist Asker" badge via the new Community Badges feature. The proposed badge's requirement would be exactly the same as the ...
- 19.9k
4
votes
1
answer
70
views
How can I have a parameter in SEDE that can be compared with multiple DATETIME values?
Let's say I want to write a SEDE query that takes a SEDE parameter (##date_param...##) with input of the form YYYY-MM-DD, and want to compare the provided parameter value against multiple columns of a ...
starballMod
- 38.1k
14
votes
1
answer
224
views
CREATE TABLE permission denied in database 'tempdb' when running SEDE_INEACHDB
Around a year ago, it was reported that "permission denied" error when running cross-site query but that got resolved (magically?) the same day.
It looks we have a regression because this ...
reneMod
- 94.8k
9
votes
1
answer
125
views
Is there an issue with non-ascii tags in Posts SEDE or data-dump?
From what I read in other questions, Tags originaly did not allowed non-ascii values. It is now very common in some sites, e.g. Ukrainian Language.
It however looks like the non-ascii Tags do not ...
- 271
2
votes
0
answers
118
views
Which table in the database contains records of users' reputation gains? [duplicate]
I downloaded the SE dataset, which contains eight XML files, but I didn't see any records of users obtaining reputation? Is it in that record?I couldn't find it in the introduction of the dataset, but ...
- 29
1
vote
1
answer
131
views
Is there an issue in PostLinks.xml generation in data dumps?
When I download a dump of a StackExchange website, I expect the PostLinks.xml file to contains all items viewable as Linked and Related in the right sidebar of questions.
When I looked for instance at ...
- 271
6
votes
1
answer
231
views
Opinion-based questions are missing from SEDE
I can't find posts from the new opinion-based questions experiment in SEDE. I've tried it with a slightly older one where I know the Id (79805930) and it is not in the Posts nor the PostsWithDeleted ...
- 200k
14
votes
1
answer
221
views
Use 'correct' site name for English.SE (and others) on SEDE
The Stack Exchange Data Explorer uses inconsistent naming for English Language & Usage Stack Exchange. The main site is abbreviated to English, the meta site uses the canonical name, with 'and' ...
GlorfindelMod
- 271k
3
votes
1
answer
196
views
How to sort all Stack Exchange sites by their average time to approve suggested edits?
How can I list all Stack Exchange sites in order of their average duration to approve suggested edits? I'd like to know which sites approve suggested edits the fastest, the slowest.
- 141
2
votes
0
answers
136
views
How to do fast pagination in the Data Explorer?
I'm trying to find the questions of a deleted user for a tag. Without any kind of pagination, I get 429 errors and never any results.
So now I've written this query using skip-to-creationdate ...
- 129
25
votes
1
answer
291
views
SEDE is hitting the 429 error way too often due to how SEDE works
There have been a couple of previous reports on 429 errors when using SEDE. There is one marked status-norepro and I'm here to re-raise that issue, not as a support ticket but as a bug.
Here is ...
reneMod
- 94.8k
31
votes
2
answers
532
views
Unable to run any SEDE queries as Cloudflare keeps blocking them from running with a verification screen
I'm unable to run any single Stack Exchange Data Explorer query. I keep getting an error that "something unexpected went wrong while running your query".
Per this prior post, this happens ...
2
votes
0
answers
141
views
Contradictory SEDE error message “A severe error occurred on the current command… Operation cancelled by user” even though I never canceled operation?
I encountered this error message when trying to run a SEDE query (screenshot):
Line 0: A severe error occurred on the current command. The results, if any, should be discarded. Operation cancelled by ...
4
votes
0
answers
158
views
Downloading a SEDE execution plan leads to an internal server error
Steps to reproduce:
Create a simple query like SELECT TOP 1 * FROM Posts
Check the 'Include execution plan' option and click 'Run Query'
Click the navigation tab 'Execution Plan', it's shown as a ...
GlorfindelMod
- 271k