Communities

Writing
Writing
Codidact Meta
Codidact Meta
The Great Outdoors
The Great Outdoors
Photography & Video
Photography & Video
Scientific Speculation
Scientific Speculation
Cooking
Cooking
Electrical Engineering
Electrical Engineering
Judaism
Judaism
Languages & Linguistics
Languages & Linguistics
Software Development
Software Development
Mathematics
Mathematics
Christianity
Christianity
Code Golf
Code Golf
Music
Music
Physics
Physics
Linux Systems
Linux Systems
Power Users
Power Users
Tabletop RPGs
Tabletop RPGs
Community Proposals
Community Proposals
tag:snake search within a tag
answers:0 unanswered questions
user:xxxx search by author id
score:0.5 posts with 0.5+ score
"snake oil" exact phrase
votes:4 posts with 4+ votes
created:<1w created < 1 week ago
post_type:xxxx type of post
Search help
Notifications
Mark all as read See all your notifications »

Welcome to Software Development on Codidact!

Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.

Activity for Sigma‭

Type On... Excerpt Status Date
Comment Post #289967 Also - very open to a better title, wasn't sure what to call this.
(more)
about 1 year ago
Edit Post #289967 Initial revision about 1 year ago
Question Redshift int casting from varchar - how to force early evaluation order?
Context: I have a varchar column in a segment event table that contains version numbers. Most of these are formatted nicely as X.Y.Z (major.minor.patch) where X, Y, and Z are integers. However, there are a few bad values, e.g. X.Y.Z-a, X.Y.Z-testing, etc. that I want to exclude entirely. I've con...
(more)
about 1 year ago
Edit Post #289775 Post edited:
about 1 year ago
Edit Post #289775 Initial revision about 1 year ago
Answer A: How do I pass field names containing dashes in dbt source yml file?
There may be a better way to handle this but this eventually worked for me. It's necessary to add `quote: true` below each field name with a dash. E.g.: ``` tables: - name: mytable columns: - name: some-field-with-dash quote: true ``` I found this ...
(more)
about 1 year ago
Edit Post #289765 Initial revision about 1 year ago
Question How do I pass field names containing dashes in dbt source yml file?
Working with dbt version 2 I'm trying to set up source checks but I'm running into an issue where the column names I'm setting tests for have dashes (e.g. `mytable.some-field-with-dash`). I currently get e.g. the following error when running dbt test: "Database Error in test testname: column "som...
(more)
about 1 year ago
Edit Post #288145 Initial revision over 1 year ago
Question How do I return ISO day of week in Redshift?
I have a query summarizing some transaction data that I'd like to summarize by day of week. For my use case, I need to return weekdays formatted according to ISO 8601, so Monday must be the first day of the week and Sunday the last day of the week. Postgres/Redshift by default use Sunday as the f...
(more)
over 1 year ago
Edit Post #284906 Initial revision about 3 years ago
Question How do I remove the column options menu from an embedded Look?
I have a Looker table look displayed to users using SSO embedding in an iframe. When displayed to users, the users can access the column options menu via a cog-wheel dropdown. In Admin > Platform > Embed I have the "Show filters on embedded looks" option disabled. What do I need to do to keep...
(more)
about 3 years ago
Comment Post #282541 In this case I will be programming it, or at least a POC. My coding skills are rather low to mediocre, but I have a deep understanding of both the underlying data relationships and the overall business domain. I have not really determined how the business rules will be tested. We currently have a ver...
(more)
over 3 years ago
Edit Post #282541 Initial revision over 3 years ago
Question What is a good modern language to use for a Business Rules project?
This is a rather vague question, but I'm trying to solve a specific problem and I'm inexperienced in most of the potential solutions, so please forgive the inherent ambiguity. I have access to a database with millions of historical financial transactions, with new transactions being added every d...
(more)
over 3 years ago
Comment Post #278633 Sorry for the delay @r~~, I've been on vacation this week and am only now seeing your comment. Since the post is closed I can no longer edit, alas.
(more)
about 4 years ago
Edit Post #278633 Initial revision about 4 years ago
Answer A: Site scope - draft proposal
Is a question about importing data into Excel on topic (as seen here)? This seems like it would fall under "questions about computers or software that are not connected to software development/engineering" as Excel is a general purpose spreadsheet software, and the question does not address formulas ...
(more)
about 4 years ago
Comment Post #278621 @Moshi It's very similar to an Excel pivot table - in general summarizing multi-dimensional data with rows and columns is called pivoting data. The row / column / values are called pivots.
(more)
about 4 years ago
Edit Post #278632 Initial revision about 4 years ago
Answer A: How to pivot text?
This seems to be looking at the outcome of a bracket in which successive players show an outcome. The table can be easily created by looking at each combination of players and listing them in the table using the index-match combination to find the correct value. Combinations that are not found in the...
(more)
about 4 years ago
Comment Post #278335 Note that super-assigning directly to the global environment is generally frowned upon as each time the function is called it will change (or create) that global variable. It is preferable for the function to return the value and then it can be assigned - this way you don't have to worry about the gl...
(more)
about 4 years ago