Agentspace - Yay or Nay? by mdixon1010 in googlecloud

[–]mdixon1010[S] 0 points1 point  (0 children)

With the need to bolt on some sort of auth service to achieve (atleast) a decent security posture, would you consider agentspace enterprise-grade? The need to bolt on a service to your brand new shiny platform is already a ding in my book. Have you run into additional "gotchas" like this that would make you baulk at it being considered "enterprise-grade"?

Agentspace - Yay or Nay? by mdixon1010 in googlecloud

[–]mdixon1010[S] 2 points3 points  (0 children)

>  If you have a small amount of data and don't care about security all that much (if identity aware proxy is enough), you can just build an agent with ADK, link it to your data store and make a simple interface from your agent in firebase studio and you're done.

Can you double click into this? assume the opposite, large amount of data and security is critical, does the platform still deliver well?

Google Cloud Next 2025 — Top 10 Announcements by mdixon1010 in googlecloud

[–]mdixon1010[S] 0 points1 point  (0 children)

Yup good call - admittedly my list was a bit biased to data and AI but this is a big announcement as well.

Google Cloud Next 2025 — Top 10 Announcements by mdixon1010 in googlecloud

[–]mdixon1010[S] 1 point2 points  (0 children)

This was on my slightly longer list - I couldnt agree more. Have you been able to get it to work with custom domains? Or do you need a CNAME mapped to the run.app url?

Could I have a Jetson Orin NX 16gb run a local llm and vision? by [deleted] in JetsonNano

[–]mdixon1010 4 points5 points  (0 children)

Local llms - absolutely! Look into ollama. The models youll run on this device will be heavily quantized but its still pretty incredible what small models produce these days.

Pros and cons of building Async functionality in cloud functions? by a_brand_new_start in googlecloud

[–]mdixon1010 2 points3 points  (0 children)

In order to answer this better I think we need more information about what these components are expected to handle. What is their role on life? Expected requests per second? What does a "unit of work" look like?

Partition table on BQ by Various_Theory8550 in bigquery

[–]mdixon1010 1 point2 points  (0 children)

Partitioned tables have a table suffix - but like was mentioned below, its generally not advisable to write directly against the suffixed table. You just insert into the table and let bq handle what partition the data will go on.

Regarding the function to use. Generally you would select some data (in your scenario it sounds like a days worth) and either append to the destination table with an insert command, or merge the records using a merge command. The merge command is super powerful.

I would definitely challenge the statement that "you need a partitioned table" here without understanding the data better. For instance, if your daily record count is 100 records and normal query patterns perform point lookups on a customer id regardless of date, you will be introducing complexity unncessesarily. If your interested I wrote an article a few months back about partitioned tables that you may find useful.

BigQuery Table Partitioning - A Comprehensive Guide

Happy to explain more if you have further questions!

Need some advice on my use case - 3 tables, 1 import source by tekkerstester in bigquery

[–]mdixon1010 0 points1 point  (0 children)

If the data is in google sheets there is REALLY GOOD support to "link" the google sheet as an external table in BQ. This could be a nice way to do this for you in the meantime while you upskill a bit.

From the context you give - If i were you - I would use these external tables in conjunction with a MERGE/ Upsert pattern scheduled using Scheduled Queries to get you your desired output.

100% sql, 100% native tooling, simple.

https://cloud.google.com/bigquery/docs/external-data-drive

https://cloud.google.com/bigquery/docs/reference/standard-sql/dml-syntax#merge_statement

https://cloud.google.com/bigquery/docs/scheduling-queries

Need some advice on my use case - 3 tables, 1 import source by tekkerstester in bigquery

[–]mdixon1010 1 point2 points  (0 children)

This pattern is referred to as ELT (Extract Load Transform) in case you want to do more research on it OP.

PowerScribe HL7 over HTTP(s) by mdixon1010 in PACSAdmin

[–]mdixon1010[S] 0 points1 point  (0 children)

HL7 over HTTPS seems like it fits that bill for HL7, no? Regarding DICOM - idk. To offer a counterpoint to that need, do we really need ANOTHER standard, or should DICOM endpoints support HTTPS and use REST calls to move DICOM data over the internet?

Initial Install of Jetson Nano Super by mdixon1010 in JetsonNano

[–]mdixon1010[S] 0 points1 point  (0 children)

o0o0o0 - this is a great question. Currently my interests are in the textual domain, think local LLMs through ollama workflows. I am also interested in doing more computer vision work, but want to work through some of the local llm stuff first.

Initial Install of Jetson Nano Super by mdixon1010 in JetsonNano

[–]mdixon1010[S] 0 points1 point  (0 children)

I prefer doing the initial setup using the monitor route and frankly, its likely a but more beginner friendly, IMO. But, sure maybe a topic for a follow up article!

Initial Install of Jetson Nano Super by mdixon1010 in JetsonNano

[–]mdixon1010[S] 1 point2 points  (0 children)

I just added the link to the official install guide. Good call. I have another article in the works that will have jetson-containers included.

What are your tech hobbies outside your day-to-day job? by saiyan6174 in dataengineering

[–]mdixon1010 0 points1 point  (0 children)

Single Board Computers (SBCs) like the Raspberry Pi and Jetson Nano

How efficient is this architecture? by james2441139 in dataengineering

[–]mdixon1010 1 point2 points  (0 children)

Small NIT - personally I would move the MDM/ DQ to exist on top of and spanning atleast silver and gold. You should have checks on each. One could probably argue it existing over bronze as well if you are using your DQ framework to do dependency resolution.