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 |