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 |
|---|---|---|---|---|
| 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) |
— | 7 months 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) |
— | 8 months 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) |
— | 8 months 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) |
— | 12 months 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) |
— | over 2 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) |
— | almost 3 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) |
— | over 3 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) |
— | over 3 years ago |